
import altair as alt # Loading the altair library
import pandas as pd


alt.data_transformers.disable_max_rows()

DataTransformerRegistry.enable('default')


# data from 2012
# https://drive.google.com/file/d/1fXJjst0rrlrFauppA8odQXOrdCEcmLaN/view?usp=sharing
Chicago = pd.read_csv('https://drive.google.com/uc?id=1fXJjst0rrlrFauppA8odQXOrdCEcmLaN')
Chicago


Chicago = Chicago.dropna()


Chicago_theft_sample = Chicago.sample(frac=1, random_state=42)
Chicago_theft_data = Chicago_theft_sample[Chicago_theft_sample["Primary Type"] == "THEFT"]
Chicago_theft_data


theft_counts_by_area = Chicago_theft_data.groupby('Community Area').size().reset_index()
theft_counts_by_area.columns = ['Community Area', 'Theft Count']

print(theft_counts_by_area)

    Community Area  Theft Count
0              1.0          959
1              2.0          963
2              3.0         1340
3              4.0          691
4              5.0          679
..             ...          ...
72            73.0          738
73            74.0          193
74            75.0          636
75            76.0          542
76            77.0          994

[77 rows x 2 columns]


df =pd.DataFrame(Chicago_theft_data)
print (df)

             ID Case Number                    Date                   Block  \
22474   8921124    HV592953  12/03/2012 10:00:00 PM         026XX W 35TH PL   
155202  8706239    HV382465  07/14/2012 01:30:00 AM    052XX S MICHIGAN AVE   
192972  8648938    HV324042  06/08/2012 04:15:00 AM     003XX N LA SALLE DR   
219443  8609272    HV282904  05/12/2012 02:00:00 AM   019XX W DIVERSEY PKWY   
87969   8813861    HV487221  09/21/2012 12:00:00 PM   007XX S CLAREMONT AVE   
...         ...         ...                     ...                     ...   
264876  8535449    HV212046  03/23/2012 08:30:00 PM      001XX W HUBBARD ST   
65276   8862096    HV535499  10/16/2012 04:00:00 PM         027XX E 89TH ST   
280207  8510397    HV187643  03/07/2012 07:30:00 PM  054XX N CUMBERLAND AVE   
192808  8650043    HV324578  06/08/2012 09:30:00 AM    024XX W ROOSEVELT RD   
55272   8864755    HV538265  10/27/2012 12:00:00 PM      013XX N STATE PKWY   

        IUCR Primary Type                    Description  \
22474   0840        THEFT  FINANCIAL ID THEFT: OVER $300   
155202  0890        THEFT                  FROM BUILDING   
192972  0870        THEFT                 POCKET-PICKING   
219443  0820        THEFT                 $500 AND UNDER   
87969   0820        THEFT                 $500 AND UNDER   
...      ...          ...                            ...   
264876  0890        THEFT                  FROM BUILDING   
65276   0820        THEFT                 $500 AND UNDER   
280207  0890        THEFT                  FROM BUILDING   
192808  0820        THEFT                 $500 AND UNDER   
55272   0890        THEFT                  FROM BUILDING   

            Location Description  Arrest  Domestic  ...  \
22474                      OTHER   False     False  ...   
155202                     OTHER   False     False  ...   
192972                    STREET    True     False  ...   
219443                    STREET   False     False  ...   
87969                     STREET   False     False  ...   
...                          ...     ...       ...  ...   
264876                RESTAURANT   False     False  ...   
65276   SCHOOL, PUBLIC, BUILDING   False     False  ...   
280207                     OTHER   False     False  ...   
192808               GAS STATION   False     False  ...   
55272                HOTEL/MOTEL   False     False  ...   

                             Location  Historical Wards 2003-2015  Zip Codes  \
22474   (41.829258146, -87.690690891)                        29.0    22248.0   
155202  (41.799858243, -87.622596769)                        12.0    21192.0   
192972  (41.888599915, -87.632510468)                        22.0     4446.0   
219443  (41.932306289, -87.676441918)                        16.0    21190.0   
87969   (41.872184627, -87.684966578)                        48.0    21184.0   
...                               ...                         ...        ...   
264876  (41.890013524, -87.631664996)                        22.0     4446.0   
65276    (41.73365047, -87.557845321)                        43.0    21202.0   
280207   (41.97855782, -87.836588785)                        34.0     4448.0   
192808  (41.866604054, -87.686645691)                        11.0    14920.0   
55272   (41.906054951, -87.628752556)                        22.0    14926.0   

        Community Areas Census Tracts  Wards  Boundaries - ZIP Codes  \
22474              55.0         638.0    1.0                    56.0   
155202              7.0         218.0    9.0                    10.0   
192972             37.0         670.0   36.0                    55.0   
219443             68.0         649.0   40.0                    16.0   
87969              29.0         757.0   23.0                    28.0   
...                 ...           ...    ...                     ...   
264876             37.0         670.0   36.0                    55.0   
65276              42.0         508.0   37.0                    25.0   
280207             36.0         735.0   29.0                    31.0   
192808             29.0          96.0   23.0                    43.0   
55272              37.0          17.0   11.0                    54.0   

        Police Districts Police Beats  Wards 2023-  
22474               23.0         96.0         12.0  
155202              24.0        111.0          8.0  
192972              14.0         73.0         42.0  
219443               5.0        172.0         32.0  
87969               15.0        139.0         28.0  
...                  ...          ...          ...  
264876              14.0         73.0         42.0  
65276               19.0        238.0          5.0  
280207              12.0         44.0         41.0  
192808              21.0        151.0         28.0  
55272               14.0        197.0          2.0  

[74683 rows x 31 columns]


ChicagoGeo = "https://gist.githubusercontent.com/juliasharkowicz/b0c20ccfc65a46bf1881657d35161b41/raw/32eb6f20c1aa98ce137b607fb598c9a7dd16eac0/gistfile1.txt"
geodata_chicago = alt.Data(url=ChicagoGeo, format=alt.DataFormat(property="features", type="json"))

chicago_land = alt.Chart(geodata_chicago).mark_geoshape(
    stroke='white',
    fill='lightgray'
).properties(
    width=800,  # Set the width to make the map wider
    height=600  # You can adjust the height as needed
)

chicago_land


import altair as alt
import pandas as pd


Chicago1 = Chicago.head(5000)

Chicago2 = alt.Chart(Chicago1).mark_circle(opacity=0.4).encode(
    longitude =('Long:Q'),
    latitude = ('Lat:Q'),
    tooltip=['Long:Q', 'Lat:Q', 'Primary Type', 'Community Area'],
    color=alt.Color('Primary Type:N', scale=alt.Scale(scheme='magma') )  # Set color scheme to 'viridis'
).project(type ='albersUsa')
chicago_land + Chicago2

/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():


Chicago_theft_map = Chicago_theft_data.head(10000)

# Now, you can use this filtered dataframe to create your chart
Chicago3 = alt.Chart(Chicago_theft_map).mark_circle(opacity=0.2).encode(
    longitude=('Longitude:Q'),
    latitude=('Latitude:Q'),
    tooltip=['Longitude:Q', 'Latitude:Q', 'Primary Type','Community Area'],
    color=alt.Color('Primary Type:N', scale=alt.Scale(scheme='tableau10'))
).project(
    type='albersUsa'
)

# Assuming you've already defined chicago_land somewhere
chicago_land + Chicago3


# merged the data sets using geodatamerger (merged the crime CSV with a CSV for socioeconomic factors)
# merged on "Community Area Number"and "community areas"
# https://drive.google.com/file/d/1c4_78Np5-DGePRzUGVLGrSluBoB2qo1l/view?usp=sharing
socioeconomicMerge = pd.read_csv("https://drive.google.com/uc?id=1c4_78Np5-DGePRzUGVLGrSluBoB2qo1l")
socioeconomicMerge

Chicago[['Latitude', 'Longitude']] = Chicago['Location'].str.extract(r'\((.*), (.*)\)')

Chicago['Latitude'] = pd.to_numeric(Chicago['Latitude'], errors='coerce')
Chicago['Longitude'] = pd.to_numeric(Chicago['Longitude'], errors='coerce')
import pandas as pd

pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)
pd.set_option('display.width', 1000)

/tmp/ipykernel_303/3919695009.py:7: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  Chicago[['Latitude', 'Longitude']] = Chicago['Location'].str.extract(r'\((.*), (.*)\)')
/tmp/ipykernel_303/3919695009.py:9: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  Chicago['Latitude'] = pd.to_numeric(Chicago['Latitude'], errors='coerce')
/tmp/ipykernel_303/3919695009.py:10: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  Chicago['Longitude'] = pd.to_numeric(Chicago['Longitude'], errors='coerce')


# calculates the percentage of crimes that are theft in each community area
grouped = Chicago.groupby('Community Area').apply(lambda x: (x['Primary Type'] == 'THEFT').sum() / len(x) * 100).reset_index()
grouped.columns = ['Community Area Number', 'Theft Percentage']

# Merge the theft percentage with your existing dataframe
socioeconomicMerge = socioeconomicMerge.merge(grouped, on='Community Area Number', how='left')



socioeconomicMerge


# calculates
theft_counts = Chicago.groupby('Community Area').apply(lambda x: (x['Primary Type'] == 'THEFT').sum()).reset_index()
theft_counts.columns = ['Community Area Number', 'Theft Count']

# Merge the theft counts with the socioeconomicMerge dataframe
socioeconomicMerge = socioeconomicMerge.merge(theft_counts, on='Community Area Number', how='left')

# Fill NaN values in 'Theft Count' column with 0 (assuming that NaN means no thefts were reported)
#socioeconomicMerge['Theft Count'] = socioeconomicMerge['Theft Count'].fillna(0)


socioeconomicMerge


import altair as alt

# Prepare the data for the grouped bar chart: melt the DataFrame
melted_data = socioeconomicMerge.melt(id_vars='COMMUNITY AREA NAME',
                                      value_vars=['Theft Percentage', 'PERCENT HOUSEHOLDS BELOW POVERTY'],
                                      var_name='Metric',
                                      value_name='Percentage')

# Create the grouped bar chart
chart = alt.Chart(melted_data).mark_bar().encode(
    x=alt.X('COMMUNITY AREA NAME:N', axis=alt.Axis(title='Community Area', labelAngle=-45)),  # Adjust label angle for readability
    y=alt.Y('Percentage:Q', axis=alt.Axis(title='Percentage (%)')),  # Scale set to [0, 100]
    color='Metric:N',
    column='Metric:N',
    order=alt.Order(
      'Metric:N',
      sort='ascending'
    ),
    tooltip=['COMMUNITY AREA NAME', 'Metric', 'Percentage']
).properties(
    width=500  # Adjust width as necessary
)

chart.display()

/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():


melted_data = socioeconomicMerge.melt(id_vars='COMMUNITY AREA NAME',
                                      value_vars=['Theft Percentage', 'PERCENT HOUSEHOLDS BELOW POVERTY'],
                                      var_name='Metric',
                                      value_name='Percentage')

# Create the grouped bar chart
chart = alt.Chart(melted_data).mark_bar().encode(
    x=alt.X('Metric:N', axis=alt.Axis(title='Metric')),
    y=alt.Y('Percentage:Q', axis=alt.Axis(title='Percentage (%)')),
    color='Metric:N',
    column='COMMUNITY AREA NAME:N',
    tooltip=['COMMUNITY AREA NAME', 'Metric', 'Percentage']
).properties(
    width=40  # Width of each grouped bar set
)

chart.display()

/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():


scatter_plot = alt.Chart(socioeconomicMerge).mark_circle().encode(
    x=alt.X('Theft Percentage:Q', title='Theft Percentage (%)'),
    y=alt.Y('PERCENT HOUSEHOLDS BELOW POVERTY:Q', title='% Households Below Poverty'),
    tooltip=['COMMUNITY AREA NAME:N', 'New Theft Percentage:Q', 'PERCENT HOUSEHOLDS BELOW POVERTY:Q'],
    color=alt.Color('COMMUNITY AREA NAME:N', legend=None)  # Color each point by community area (optional)
).properties(
    width=600,  # Adjust width as needed
    height=400,  # Adjust height as needed
    title="Theft Percentage vs. % Households Below Poverty by Community Area"
)

scatter_plot.display()


scatter_plot = alt.Chart(socioeconomicMerge).mark_circle().encode(
    x=alt.X('Theft Count:Q', title='Theft Count'),
    y=alt.Y('PERCENT HOUSEHOLDS BELOW POVERTY:Q', title='% Households Below Poverty'),
    size='PERCENT HOUSEHOLDS BELOW POVERTY:Q',
    tooltip=['COMMUNITY AREA NAME:N', 'Theft Count:Q', 'PERCENT HOUSEHOLDS BELOW POVERTY:Q'],
    color=alt.Color('COMMUNITY AREA NAME:N', legend=None)  # Color each point by community area (optional)
).properties(
    width=600,  # Adjust width as needed
    height=400,  # Adjust height as needed
    title="Theft Count vs. % Households Below Poverty by Community Area"
)

scatter_plot.display()


total_thefts = socioeconomicMerge['Theft Count'].sum()
total_thefts

74683.0


# create a visualization with socioeconomic factors for Chicago overall
import pandas as pd
import altair as alt


# Extracting the CHICAGO row
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'CHICAGO']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [
    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar().encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),
    tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in All of Chicago'
    )

chicagoChart

/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():


chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Fuller Park']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [
    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='purple').encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in Fuller Park Community Area'
    )

chicagoChart

/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():


chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Riverdale']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [

    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='orange').encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in Riverdale Community Area'
    )

chicagoChart

/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():


# highest amount of thefts according to theft count
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Near North Side']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [

    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='pink').encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in Near North Side Community Area'
    )

chicagoChart

/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():


# lowest amount of thefts according to scatterplot
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Edison Park']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [

    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='green').encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in Edison Park Community Area'
    )

chicagoChart

/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():

	Community Area Number	COMMUNITY AREA NAME	PERCENT OF HOUSING CROWDED	PERCENT HOUSEHOLDS BELOW POVERTY	PERCENT AGED 16+ UNEMPLOYED	PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA	PERCENT AGED UNDER 18 OR OVER 64	PER CAPITA INCOME	HARDSHIP INDEX	ID	Case Number	Date	Block	IUCR	Primary Type	Description	Location Description	Arrest	Domestic	Beat	District	Ward	Community Area	FBI Code	X Coordinate	Y Coordinate	Year	Updated On	Latitude	Longitude	Location	Historical Wards 2003-2015	Zip Codes	Community Areas	Census Tracts	Wards	Boundaries - ZIP Codes	Police Districts	Police Beats	Wards 2023-	Theft Percentage
0	1.0	Rogers Park	7.7	23.6	8.7	18.2	27.5	23939	39.0	8522872	HV199799	01/01/2012 12:01:00 AM	068XX N SHERIDAN RD	890	THEFT	FROM BUILDING	RESIDENCE	False	False	2431	24	49	1.0	06	1166981.0	1945453.0	2012	02/04/2016 06:33:39 AM	42.005888	-87.661005	(42.005887804, -87.661005031)	3.0	21853.0	10.0	267.0	5.0	9.0	11.0	39.0	49.0	20.071159
1	2.0	West Ridge	7.8	17.2	8.8	20.8	38.5	23040	46.0	8481432	HV158191	01/01/2012 12:00:00 AM	066XX N SEELEY AVE	1754	OFFENSE INVOLVING CHILDREN	AGG SEX ASSLT OF CHILD FAM MBR	RESIDENCE	False	False	2412	24	50	2.0	02	1161424.0	1944172.0	2012	02/10/2018 03:50:01 PM	42.002491	-87.681486	(42.002490631, -87.681485671)	42.0	22528.0	20.0	320.0	27.0	12.0	11.0	46.0	40.0	24.220322
2	3.0	Uptown	3.8	24.0	8.9	11.8	22.2	35787	20.0	9786892	HX434641	01/01/2012 12:00:00 AM	008XX W EASTWOOD AVE	266	CRIM SEXUAL ASSAULT	PREDATORY	RESIDENCE	False	True	1914	19	46	3.0	02	1169806.0	1931096.0	2012	02/10/2018 03:50:01 PM	41.966431	-87.651032	(41.966430564, -87.651032417)	37.0	22616.0	31.0	19.0	39.0	15.0	5.0	4.0	46.0	27.005240
3	4.0	Lincoln Square	3.4	10.9	8.2	13.4	25.5	37524	17.0	8639260	HV313362	01/01/2012 12:01:00 AM	048XX N CLAREMONT AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	2031	20	47	4.0	06	1159822.0	1932094.0	2012	02/04/2016 06:33:39 AM	41.969381	-87.687714	(41.969381427, -87.687714236)	13.0	21849.0	6.0	54.0	18.0	20.0	2.0	61.0	47.0	29.720430
4	5.0	North Center	0.3	7.5	5.2	4.5	26.2	57123	6.0	8719401	HV387013	01/01/2012 12:00:00 AM	040XX N HOYNE AVE	1563	SEX OFFENSE	CRIMINAL SEXUAL ABUSE	RESIDENCE	False	False	1911	19	47	5.0	17	1161635.0	1926718.0	2012	02/04/2016 06:33:39 AM	41.954592	-87.681198	(41.954591739, -87.681198274)	13.0	21538.0	46.0	623.0	18.0	39.0	5.0	10.0	47.0	35.475444
5	6.0	Lake View	1.1	11.4	4.7	2.6	17.0	60058	5.0	8856125	HV529988	01/01/2012 12:00:00 AM	006XX W CORNELIA AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	1925	19	46	6.0	06	1171080.0	1923465.0	2012	02/10/2018 03:50:01 PM	41.945463	-87.646573	(41.945462922, -87.646573015)	38.0	4449.0	57.0	730.0	25.0	22.0	5.0	18.0	44.0	37.566967
6	7.0	Lincoln Park	0.8	12.3	5.1	3.6	21.5	71551	2.0	8424740	HV103697	01/01/2012 12:00:00 AM	014XX W FULLERTON AVE	460	BATTERY	SIMPLE	APARTMENT	False	False	1931	19	32	7.0	08B	1166102.0	1916039.0	2012	02/10/2018 03:50:01 PM	41.925194	-87.665083	(41.925193578, -87.66508297)	16.0	21190.0	68.0	770.0	11.0	16.0	5.0	173.0	32.0	44.323671
7	8.0	Near North Side	1.9	12.9	7.0	2.5	22.6	88669	1.0	8904856	HV578917	01/01/2012 12:00:00 AM	002XX E CHESTNUT ST	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	1833	18	42	8.0	06	1178637.0	1906397.0	2012	02/10/2018 03:50:01 PM	41.898458	-87.619319	(41.898458275, -87.619318967)	22.0	21182.0	37.0	233.0	11.0	6.0	14.0	71.0	2.0	48.858488
8	9.0	Edison Park	1.1	3.3	6.5	7.4	35.3	40959	8.0	9274751	HW419186	01/01/2012 12:00:00 AM	073XX N ORIOLE AVE	2825	OTHER OFFENSE	HARASSMENT BY TELEPHONE	RESIDENCE	False	False	1611	16	41	9.0	26	1124738.0	1948147.0	2012	02/10/2018 03:50:01 PM	42.014085	-87.816364	(42.014085475, -87.81636423)	34.0	22243.0	77.0	653.0	29.0	17.0	12.0	34.0	41.0	22.442244
9	10.0	Norwood Park	2.0	5.4	9.0	11.5	39.5	32875	21.0	9055356	HW199594	01/01/2012 12:00:00 AM	057XX N WEST CIRCLE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	STREET	False	False	1612	16	41	10.0	06	1127968.0	1937874.0	2012	02/10/2018 03:50:01 PM	41.985841	-87.804712	(41.985841282, -87.8047123)	34.0	22243.0	36.0	733.0	29.0	17.0	12.0	45.0	41.0	28.156028
10	11.0	Jefferson Park	2.7	8.6	12.4	13.4	35.5	27751	25.0	11865218	JC471748	01/01/2012 12:00:00 AM	062XX W FOSTER AVE	1750	OFFENSE INVOLVING CHILDREN	CHILD ABUSE	CHURCH/SYNAGOGUE/PLACE OF WORSHIP	False	True	1622	16	45	11.0	08B	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25.854701
11	12.0	Forest Glen	1.1	7.5	6.8	4.9	40.5	44164	11.0	8548806	HV224880	01/01/2012 12:01:00 AM	062XX N KEYSTONE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	STREET	False	False	1711	17	39	12.0	06	1148230.0	1941153.0	2012	02/04/2016 06:33:39 AM	41.994472	-87.730104	(41.9944717, -87.730103763)	28.0	22532.0	12.0	713.0	38.0	18.0	1.0	53.0	39.0	30.292599
12	13.0	North Park	3.9	13.2	9.9	14.4	39.0	26576	33.0	8679089	HV354082	01/01/2012 12:01:00 AM	040XX W PETERSON AVE	2820	OTHER OFFENSE	TELEPHONE THREAT	MEDICAL/DENTAL OFFICE	False	False	1711	17	39	13.0	26	1148144.0	1939564.0	2012	02/04/2016 06:33:39 AM	41.990113	-87.730461	(41.990113051, -87.730461261)	28.0	22532.0	13.0	748.0	38.0	18.0	1.0	53.0	39.0	30.252101
13	14.0	Albany Park	11.3	19.2	10.0	32.9	32.0	21323	53.0	8519160	HV194208	01/01/2012 12:00:00 AM	047XX N HARDING AVE	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	False	1723	17	39	14.0	17	1149205.0	1931162.0	2012	02/04/2016 06:33:39 AM	41.967037	-87.726777	(41.96703686, -87.726777496)	28.0	21849.0	14.0	117.0	12.0	20.0	1.0	9.0	33.0	20.816327
14	15.0	Portage Park	4.1	11.6	12.6	19.3	34.0	24336	35.0	8460773	HV138026	01/01/2012 12:00:00 AM	050XX W WARWICK AVE	1563	SEX OFFENSE	CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	1634	16	45	15.0	17	1142107.0	1924463.0	2012	09/07/2021 03:41:02 PM	41.948789	-87.753043	(41.948789141, -87.753043017)	20.0	22618.0	15.0	360.0	50.0	21.0	12.0	26.0	30.0	25.741142
15	16.0	Irving Park	6.3	13.1	10.0	22.4	31.6	27249	34.0	8612446	HV286559	01/01/2012 12:01:00 AM	032XX N KILDARE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	1731	17	31	16.0	06	1147143.0	1921400.0	2012	02/04/2016 06:33:39 AM	41.940289	-87.734610	(41.940288955, -87.734610033)	7.0	22618.0	16.0	328.0	21.0	21.0	1.0	25.0	30.0	21.792261
16	17.0	Dunning	5.2	10.6	10.0	16.2	33.6	26282	28.0	8630608	HV304221	01/01/2012 12:00:00 AM	065XX W BYRON ST	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	1632	16	38	17.0	17	1132230.0	1925250.0	2012	02/04/2016 06:33:39 AM	41.951127	-87.789331	(41.951126516, -87.789331374)	25.0	22254.0	17.0	444.0	19.0	52.0	12.0	17.0	38.0	23.402007
17	18.0	Montclaire	8.1	15.3	13.8	23.5	38.6	22014	50.0	13184630	JG330270	01/01/2012 12:00:00 AM	070XX W DIVERSEY AVE	1754	OFFENSE INVOLVING CHILDREN	AGGRAVATED SEXUAL ASSAULT OF CHILD BY FAMILY M...	APARTMENT	False	True	2511	25	29	18.0	02	NaN	NaN	2012	08/23/2023 03:41:55 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20.079787
18	19.0	Belmont Cragin	10.8	18.7	14.6	37.3	37.3	15461	70.0	10433096	HZ170962	01/01/2012 12:00:00 AM	026XX N MC VICKER AVE	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	True	True	2512	25	29	19.0	17	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	19.055862
19	20.0	Hermosa	6.9	20.5	13.1	41.6	36.4	15089	71.0	11002368	JA329407	01/01/2012 12:00:00 AM	021XX N KENNETH AVE	1752	OFFENSE INVOLVING CHILDREN	AGG CRIM SEX ABUSE FAM MEMBER	RESIDENCE	False	True	2522	25	31	20.0	20	NaN	NaN	2012	11/27/2017 03:53:35 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16.113281
20	21.0	Avondale	6.0	15.3	9.2	24.7	31.0	20039	42.0	9485925	HX138962	01/01/2012 12:00:00 AM	033XX N KEDZIE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	OTHER	False	False	1733	17	33	21.0	06	1154463.0	1921987.0	2012	02/04/2016 06:33:39 AM	41.941756	-87.707691	(41.941756281, -87.70769069)	15.0	21538.0	22.0	138.0	12.0	39.0	1.0	23.0	35.0	21.376147
21	22.0	Logan Square	3.2	16.8	8.2	14.8	26.2	31908	23.0	8580117	HV254276	01/01/2012 12:00:00 AM	037XX W LYNDALE ST	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	True	2525	25	35	22.0	20	1151032.0	1914695.0	2012	02/04/2016 06:33:39 AM	41.921814	-87.720493	(41.921814446, -87.720492698)	15.0	22535.0	23.0	74.0	12.0	1.0	6.0	187.0	35.0	28.799527
22	23.0	Humboldt park	14.8	33.9	17.3	35.4	38.0	13781	85.0	10440733	HZ179414	01/01/2012 12:00:00 AM	038XX W OHIO ST	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	APARTMENT	False	False	1122	11	27	23.0	11	NaN	NaN	2012	03/09/2016 04:05:56 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14.008582
23	24.0	West Town	2.3	14.7	6.6	12.9	21.7	43198	10.0	8647985	HV322951	01/01/2012 12:00:00 AM	015XX N CAMPBELL AVE	1305	CRIMINAL DAMAGE	CRIMINAL DEFACEMENT	RESIDENCE-GARAGE	False	False	1423	14	1	24.0	14	1159459.0	1910195.0	2012	02/04/2016 06:33:39 AM	41.909297	-87.689654	(41.909296674, -87.689653613)	10.0	21560.0	25.0	302.0	41.0	4.0	7.0	62.0	1.0	32.515020
24	25.0	Austin	6.3	28.6	22.6	24.4	37.9	15957	73.0	10401057	HZ137709	01/01/2012 12:00:00 AM	050XX W HURON ST	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	1532	15	28	25.0	17	NaN	NaN	2012	02/11/2016 03:47:22 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15.036232
25	26.0	West Garfield Park	9.4	41.7	25.8	24.5	43.6	10934	92.0	8421939	HV100656	01/01/2012 12:00:00 AM	044XX W WEST END AVE	890	THEFT	FROM BUILDING	RESIDENCE	False	False	1113	11	28	26.0	06	1146850.0	1900608.0	2012	02/04/2016 06:33:39 AM	41.883239	-87.736219	(41.883239213, -87.73621892)	11.0	21572.0	27.0	732.0	23.0	30.0	16.0	90.0	28.0	12.610586
26	27.0	East Garfield Park	8.2	42.4	19.6	21.3	43.2	12961	83.0	9087981	HW232769	01/01/2012 12:00:00 AM	008XX S INDEPENDENCE BLVD	841	THEFT	FINANCIAL ID THEFT:$300 &UNDER	RESIDENCE	False	False	1133	11	24	27.0	06	1151390.0	1896019.0	2012	02/10/2018 03:50:01 PM	41.870559	-87.719668	(41.870558601, -87.719668116)	36.0	21572.0	28.0	704.0	14.0	30.0	16.0	141.0	24.0	13.619433
27	28.0	Near West Side	3.8	20.6	10.7	9.6	22.2	44689	15.0	8678186	HV352296	01/01/2012 12:00:00 AM	013XX W WASHBURNE AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	False	1231	12	2	28.0	20	1167691.0	1894516.0	2012	02/04/2016 06:33:39 AM	41.866099	-87.659865	(41.866098868, -87.659865054)	48.0	14920.0	29.0	96.0	26.0	43.0	15.0	150.0	28.0	35.867363
28	29.0	North Lawndale	7.4	43.1	21.2	27.6	42.7	12034	87.0	9467940	HX120966	01/01/2012 12:00:00 AM	015XX S KEELER AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	1012	10	24	29.0	06	1148635.0	1892193.0	2012	02/10/2018 03:50:01 PM	41.860113	-87.729881	(41.860113198, -87.729881467)	36.0	21569.0	30.0	761.0	14.0	57.0	21.0	109.0	24.0	13.414282
29	30.0	South Lawndale	15.2	30.7	15.8	54.8	33.8	10402	96.0	11861733	JC473689	01/01/2012 12:00:00 AM	022XX S CALIFORNIA AVE	1754	OFFENSE INVOLVING CHILDREN	AGG SEX ASSLT OF CHILD FAM MBR	RESIDENCE	False	True	1033	10	12	30.0	02	NaN	NaN	2012	10/16/2019 09:37:36 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16.730236
30	31.0	Lower West Side	9.6	25.8	15.8	40.7	32.6	16444	76.0	8538123	HV214939	01/01/2012 12:01:00 AM	021XX W 18TH ST	1754	OFFENSE INVOLVING CHILDREN	AGG SEX ASSLT OF CHILD FAM MBR	RESIDENCE	False	False	1223	12	25	31.0	02	1162499.0	1891389.0	2012	02/04/2016 06:33:39 AM	41.857628	-87.679013	(41.857628272, -87.679012753)	8.0	14920.0	33.0	4.0	26.0	43.0	15.0	121.0	25.0	20.408163
31	32.0	Loop	1.5	14.7	5.7	3.1	13.5	65526	3.0	11655969	JC225381	01/01/2012 12:00:00 AM	001XX W RANDOLPH ST	486	BATTERY	DOMESTIC BATTERY SIMPLE	RESIDENCE	False	True	122	1	42	32.0	08B	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	53.431563
32	33.0	Near South Side	1.3	13.8	4.9	7.4	21.8	59077	7.0	8812790	HV485714	01/01/2012 12:01:00 AM	022XX S WABASH AVE	1150	DECEPTIVE PRACTICE	CREDIT CARD FRAUD	OTHER	False	False	131	1	2	33.0	11	1177098.0	1889498.0	2012	02/10/2018 03:50:01 PM	41.852121	-87.625483	(41.852121445, -87.625483421)	48.0	21194.0	34.0	193.0	9.0	40.0	22.0	94.0	8.0	39.086022
33	34.0	Armour Square	5.7	40.1	16.7	34.5	38.3	16148	82.0	8421660	HV100180	01/01/2012 01:20:00 AM	002XX W 26TH ST	430	BATTERY	AGGRAVATED: OTHER DANG WEAPON	PARKING LOT/GARAGE(NON.RESID.)	True	False	914	9	11	34.0	04B	1174834.0	1887065.0	2012	02/10/2018 03:50:01 PM	41.845496	-87.633866	(41.84549602, -87.633865582)	26.0	21194.0	35.0	346.0	48.0	40.0	23.0	157.0	7.0	27.890268
34	35.0	Douglas	1.8	29.6	18.2	14.3	30.7	23791	47.0	10532867	HZ276514	01/01/2012 12:00:00 AM	036XX S RHODES AVE	1563	SEX OFFENSE	CRIMINAL SEXUAL ABUSE	APARTMENT	False	True	212	2	4	35.0	17	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	24.791893
35	36.0	Oakland	1.3	39.7	28.7	18.4	40.4	19252	78.0	8421472	HV100138	01/01/2012 01:38:00 AM	042XX S DREXEL BLVD	486	BATTERY	DOMESTIC BATTERY SIMPLE	APARTMENT	False	True	2123	2	4	36.0	08B	1182889.0	1876982.0	2012	02/10/2018 03:50:01 PM	41.817644	-87.604619	(41.817643766, -87.604618853)	1.0	4301.0	2.0	220.0	10.0	36.0	24.0	104.0	9.0	20.984456
36	37.0	Fuller Park	3.2	51.2	33.9	26.6	44.9	10432	97.0	9836248	HX484599	01/01/2012 12:00:00 AM	001XX W GARFIELD BLVD	1130	DECEPTIVE PRACTICE	FRAUD OR CONFIDENCE GAME	CURRENCY EXCHANGE	True	False	225	2	3	37.0	11	1176228.0	1868523.0	2012	02/10/2018 03:50:01 PM	41.794584	-87.629307	(41.794583892, -87.629307346)	12.0	21559.0	66.0	166.0	9.0	37.0	24.0	111.0	20.0	20.540098
37	38.0	Grand Boulevard	3.3	29.3	24.3	15.9	39.5	23472	57.0	8424419	HV102059	01/01/2012 03:00:00 AM	046XX S PRAIRIE AVE	281	CRIM SEXUAL ASSAULT	NON-AGGRAVATED	RESIDENCE	False	False	221	2	3	38.0	02	1178818.0	1874416.0	2012	02/10/2018 03:50:01 PM	41.810696	-87.619631	(41.810696214, -87.619630513)	12.0	4301.0	4.0	354.0	9.0	36.0	24.0	98.0	8.0	17.389187
38	39.0	Kenwood	2.4	21.7	15.7	11.3	35.4	35911	26.0	8916155	HV588860	01/01/2012 12:00:00 AM	050XX S LAKE SHORE DR W	840	THEFT	FINANCIAL ID THEFT: OVER $300	APARTMENT	False	False	222	2	4	39.0	06	1188639.0	1871868.0	2012	02/10/2018 03:50:01 PM	41.803475	-87.583690	(41.803474876, -87.583690122)	1.0	21192.0	5.0	400.0	33.0	10.0	24.0	113.0	3.0	28.459821
39	40.0	Washington Park	5.6	42.1	28.6	25.4	42.8	13785	88.0	11571926	JC122968	01/01/2012 12:00:00 AM	059XX S INDIANA AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	APARTMENT	True	True	232	2	20	40.0	17	NaN	NaN	2012	08/01/2019 03:45:33 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14.751732
40	41.0	Hyde Park	1.5	18.4	8.4	4.3	26.2	39056	14.0	9091480	HW236506	01/01/2012 12:00:00 AM	055XX S COTTAGE GROVE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	235	2	5	41.0	06	1182527.0	1868455.0	2012	02/10/2018 03:50:01 PM	41.794253	-87.606211	(41.794253414, -87.606211387)	32.0	22260.0	8.0	401.0	33.0	60.0	24.0	132.0	3.0	34.500784
41	42.0	Woodlawn	2.9	30.7	23.4	16.5	36.1	18672	58.0	8821354	HV494310	01/01/2012 12:01:00 AM	063XX S ST LAWRENCE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	STREET	False	False	312	3	20	42.0	06	1181324.0	1863129.0	2012	02/10/2018 03:50:01 PM	41.779666	-87.610787	(41.779666218, -87.61078682)	53.0	22260.0	9.0	332.0	4.0	60.0	18.0	277.0	20.0	15.501576
42	43.0	South Shore	2.8	31.1	20.0	14.0	35.7	19398	55.0	9784782	HX433977	01/01/2012 12:00:00 AM	078XX S JEFFERY BLVD	265	CRIM SEXUAL ASSAULT	AGGRAVATED: OTHER	RESIDENCE	False	True	414	4	8	43.0	02	1190897.0	1853347.0	2012	09/07/2021 03:41:02 PM	41.752598	-87.576007	(41.752597535, -87.576007285)	9.0	22538.0	39.0	420.0	35.0	24.0	19.0	222.0	10.0	16.425246
43	44.0	Chatham	3.3	27.8	24.0	14.5	40.3	18881	60.0	11012707	JA342665	01/01/2012 12:00:00 AM	081XX S EVANS AVE	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	OTHER	False	False	631	6	6	44.0	11	NaN	NaN	2012	07/11/2017 03:48:22 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22.336009
44	45.0	Avalon Park	1.4	17.2	21.1	10.6	39.3	24454	41.0	8453833	HV101813	01/01/2012 12:01:00 AM	080XX S WOODLAWN AVE	1320	CRIMINAL DAMAGE	TO VEHICLE	STREET	False	False	411	4	8	45.0	14	1185609.0	1851926.0	2012	02/10/2018 03:50:01 PM	41.748824	-87.595430	(41.748824266, -87.595429995)	9.0	21546.0	41.0	133.0	35.0	61.0	19.0	224.0	10.0	25.055432
45	46.0	South Chicago	4.7	29.8	19.7	26.6	41.1	16579	75.0	8644620	HV319861	01/01/2012 12:00:00 AM	087XX S ESCANABA AVE	4651	OTHER OFFENSE	SEX OFFENDER: FAIL REG NEW ADD	RESIDENCE	True	False	423	4	10	46.0	26	1196905.0	1847568.0	2012	02/04/2016 06:33:39 AM	41.736592	-87.554183	(41.736592286, -87.554182677)	47.0	21202.0	42.0	509.0	47.0	25.0	19.0	238.0	6.0	14.649984
46	47.0	Burnside	6.8	33.0	18.6	19.3	42.7	12515	79.0	9535590	HX189319	01/01/2012 12:00:00 AM	092XX S DREXEL AVE	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	APARTMENT	False	False	413	4	8	47.0	11	1184166.0	1844031.0	2012	02/10/2018 03:50:01 PM	41.727193	-87.600964	(41.727193361, -87.600963809)	9.0	21546.0	43.0	472.0	35.0	61.0	19.0	246.0	10.0	17.415730
47	48.0	Calumet Heights	2.1	11.5	20.0	11.0	44.0	28887	38.0	8421496	HV100177	01/01/2012 02:10:00 AM	023XX E 91ST ST	2025	NARCOTICS	POSS: HALLUCINOGENS	STREET	True	False	413	4	7	48.0	18	1193236.0	1845085.0	2012	02/10/2018 03:50:01 PM	41.729869	-87.567705	(41.729869072, -87.56770535)	43.0	21202.0	44.0	492.0	37.0	25.0	19.0	246.0	5.0	29.205852
48	49.0	Roseland	2.5	19.8	20.3	16.9	41.2	17949	52.0	8630662	HV304328	01/01/2012 12:00:00 AM	111XX S PARNELL AVE	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	2233	22	34	49.0	17	1174621.0	1831009.0	2012	02/04/2016 06:33:39 AM	41.691677	-87.636314	(41.691676649, -87.636314398)	45.0	21861.0	45.0	486.0	22.0	19.0	9.0	258.0	21.0	15.912117
49	50.0	Pullman	1.5	21.6	22.8	13.1	38.6	20588	51.0	10579715	HZ328636	01/01/2012 12:00:00 AM	007XX E 105TH PL	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	512	5	9	50.0	17	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16.454690
50	51.0	South Deering	4.0	29.2	16.3	21.0	39.5	14685	65.0	9006102	HW153435	01/01/2012 12:01:00 AM	097XX S BRENNAN AVE	841	THEFT	FINANCIAL ID THEFT:$300 &UNDER	RESIDENCE	False	False	431	4	7	51.0	06	1193243.0	1840695.0	2012	02/10/2018 03:50:01 PM	41.717822	-87.567823	(41.717822323, -87.567822714)	43.0	21202.0	48.0	252.0	37.0	25.0	19.0	249.0	5.0	17.918314
51	52.0	East Side	6.8	19.2	12.1	31.9	42.8	17104	64.0	9130410	HW275140	01/01/2012 12:00:00 AM	109XX S BUFFALO AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	True	432	4	10	52.0	20	1199876.0	1833114.0	2012	09/07/2021 03:41:02 PM	41.696855	-87.543784	(41.696854988, -87.54378378)	47.0	21202.0	49.0	602.0	47.0	25.0	19.0	247.0	6.0	15.531178
52	53.0	West Pullman	3.3	25.9	19.4	20.5	42.1	16563	62.0	10928592	JA154782	01/01/2012 12:00:00 AM	0000X E 118TH PL	1752	OFFENSE INVOLVING CHILDREN	AGG CRIM SEX ABUSE FAM MEMBER	RESIDENCE	True	True	532	5	9	53.0	20	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14.940518
53	54.0	Riverdale	5.8	56.5	34.6	27.5	51.5	8201	98.0	12364874	JE229312	01/01/2012 12:00:00 AM	131XX S FORRESTVILLE AVE	1581	SEX OFFENSE	NON-CONSENSUAL DISSEMINATION OF PRIVATE SEXUAL...	RESIDENCE	False	False	533	5	9	54.0	17	NaN	NaN	2012	05/14/2021 03:40:44 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11.047619
54	55.0	Hegewisch	3.3	17.1	9.6	19.2	42.9	22677	44.0	8438703	HV116214	01/01/2012 12:01:00 AM	134XX S AVENUE M	2820	OTHER OFFENSE	TELEPHONE THREAT	RESIDENCE	False	True	433	4	10	55.0	26	1201758.0	1816513.0	2012	02/10/2018 03:50:01 PM	41.651253	-87.537455	(41.65125265, -87.537454574)	47.0	22250.0	52.0	787.0	47.0	26.0	19.0	259.0	6.0	19.376694
55	56.0	Garfield Ridge	2.6	8.8	11.3	19.3	38.1	26353	32.0	8964421	HW112128	01/01/2012 12:01:00 AM	044XX S KILPATRICK AVE	841	THEFT	FINANCIAL ID THEFT:$300 &UNDER	RESIDENCE	False	False	815	8	23	56.0	06	1145771.0	1874717.0	2012	02/10/2018 03:50:01 PM	41.812211	-87.740837	(41.812211369, -87.740837061)	35.0	22248.0	53.0	566.0	28.0	56.0	13.0	105.0	22.0	22.066694
56	57.0	Archer Heights	8.5	14.1	16.5	35.9	39.2	16134	67.0	8550554	HV226299	01/01/2012 12:01:00 AM	050XX S KOLIN AVE	1752	OFFENSE INVOLVING CHILDREN	AGG CRIM SEX ABUSE FAM MEMBER	RESIDENCE	False	False	815	8	23	57.0	20	1148213.0	1870883.0	2012	02/10/2018 03:50:01 PM	41.801644	-87.731978	(41.801643749, -87.731978113)	35.0	22248.0	54.0	697.0	8.0	56.0	13.0	105.0	14.0	21.171548
57	58.0	Brighton Park	14.4	23.6	13.9	45.1	39.3	13089	84.0	10774674	HZ540883	01/01/2012 12:01:00 AM	045XX S TROY ST	266	CRIM SEXUAL ASSAULT	PREDATORY	RESIDENCE	False	True	922	9	14	58.0	02	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15.966123
58	59.0	McKinley Park	7.2	18.7	13.4	32.9	35.6	16954	61.0	8558693	HV234189	01/01/2012 12:00:00 AM	037XX S WOLCOTT AVE	610	BURGLARY	FORCIBLE ENTRY	RESIDENCE	False	False	912	9	11	59.0	05	1164301.0	1879957.0	2012	02/04/2016 06:33:39 AM	41.826220	-87.672721	(41.826219832, -87.67272111)	26.0	14924.0	56.0	720.0	1.0	37.0	23.0	165.0	12.0	27.761194
59	60.0	Bridgeport	4.5	18.9	13.7	22.2	31.3	22694	43.0	8697316	HV373879	01/01/2012 12:00:00 AM	027XX S EMERALD AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	False	914	9	11	60.0	20	1171748.0	1886502.0	2012	02/04/2016 06:33:39 AM	41.844020	-87.645207	(41.844019513, -87.645207358)	26.0	21194.0	58.0	688.0	48.0	40.0	23.0	157.0	7.0	23.706100
60	61.0	New City	11.9	29.0	23.0	41.5	38.9	12765	91.0	11419858	JB400896	01/01/2012 12:00:00 AM	047XX S WOOD ST	1754	OFFENSE INVOLVING CHILDREN	AGG SEX ASSLT OF CHILD FAM MBR	APARTMENT	True	True	931	9	15	61.0	02	NaN	NaN	2012	01/24/2019 04:13:10 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16.715586
61	62.0	West Elsdon	11.1	15.6	16.7	37.0	37.7	15754	69.0	8509166	HV186479	01/01/2012 12:01:00 AM	051XX S PULASKI RD	1305	CRIMINAL DAMAGE	CRIMINAL DEFACEMENT	DEPARTMENT STORE	True	False	815	8	23	62.0	14	1150563.0	1870470.0	2012	02/10/2018 03:50:01 PM	41.800465	-87.723370	(41.800464977, -87.723370404)	35.0	22248.0	60.0	792.0	6.0	56.0	13.0	129.0	23.0	21.418129
62	63.0	Gage Park	15.8	23.4	18.2	51.5	38.8	12171	93.0	8688452	HV363336	01/01/2012 12:00:00 AM	055XX S HOMAN AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	OTHER	False	False	822	8	14	63.0	06	1154655.0	1867673.0	2012	02/04/2016 06:33:39 AM	41.792709	-87.708438	(41.792708947, -87.708438164)	49.0	21867.0	61.0	801.0	8.0	58.0	13.0	129.0	14.0	17.424946
63	64.0	Clearing	2.7	8.9	9.5	18.8	37.6	25113	29.0	9030494	HW173536	01/01/2012 12:00:00 AM	063XX W 63RD ST	890	THEFT	FROM BUILDING	BANK	False	False	812	8	23	64.0	06	1135055.0	1862066.0	2012	02/10/2018 03:50:01 PM	41.777691	-87.780442	(41.777690785, -87.780442441)	35.0	22268.0	62.0	265.0	15.0	7.0	13.0	272.0	13.0	20.194647
64	65.0	West Lawn	5.8	14.9	9.6	33.6	39.6	16907	56.0	10244439	HY432505	01/01/2012 12:00:00 AM	039XX W 63RD PL	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	RESIDENCE	False	False	823	8	13	65.0	11	1151174.0	1862198.0	2012	02/10/2018 03:50:01 PM	41.777753	-87.721346	(41.777753427, -87.721345586)	23.0	21867.0	63.0	238.0	15.0	58.0	13.0	276.0	23.0	32.592593
65	66.0	Chicago Lawn	7.6	27.9	17.1	31.2	40.6	13231	80.0	8511440	HV188411	01/01/2012 12:00:00 AM	030XX W 64TH ST	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	823	8	15	66.0	06	1157262.0	1862044.0	2012	02/04/2016 06:33:39 AM	41.777210	-87.699031	(41.777209768, -87.69903082)	44.0	21867.0	64.0	319.0	31.0	58.0	13.0	276.0	15.0	15.625000
66	67.0	West Englewood	4.8	34.4	35.9	26.3	40.7	11317	89.0	8422478	HV100112	01/01/2012 12:00:00 AM	057XX S THROOP ST	486	BATTERY	DOMESTIC BATTERY SIMPLE	VEHICLE NON-COMMERCIAL	False	True	713	7	16	67.0	08B	1168636.0	1866805.0	2012	09/07/2021 03:41:02 PM	41.790037	-87.657197	(41.790036743, -87.657196537)	19.0	22257.0	65.0	297.0	2.0	23.0	17.0	266.0	16.0	15.349910
67	68.0	Englewood	3.8	46.6	28.0	28.5	42.5	11888	94.0	8489737	HV166954	01/01/2012 12:00:00 AM	067XX S NORMAL BLVD	1150	DECEPTIVE PRACTICE	CREDIT CARD FRAUD	RESIDENCE	False	False	722	7	6	68.0	11	1174118.0	1859976.0	2012	02/10/2018 03:50:01 PM	41.771177	-87.637298	(41.771177146, -87.637298335)	31.0	21559.0	66.0	479.0	32.0	11.0	17.0	201.0	4.0	15.333774
68	69.0	Greater Grand Crossing	3.6	29.6	23.0	16.5	41.0	17285	66.0	8577653	HV252006	01/01/2012 12:01:00 AM	001XX E 78TH ST	2825	OTHER OFFENSE	HARASSMENT BY TELEPHONE	APARTMENT	False	False	623	6	6	69.0	26	1178686.0	1853331.0	2012	02/04/2016 06:33:39 AM	41.752840	-87.620756	(41.752839871, -87.620755566)	31.0	21546.0	67.0	475.0	32.0	61.0	20.0	228.0	4.0	15.270766
69	70.0	Ashburn	4.0	10.4	11.7	17.7	36.9	23482	37.0	8621247	HV291039	01/01/2012 12:00:00 AM	028XX W 84TH PL	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	835	8	18	70.0	06	1158673.0	1848550.0	2012	02/04/2016 06:33:39 AM	41.740151	-87.694226	(41.740151493, -87.694225587)	6.0	4300.0	69.0	217.0	30.0	8.0	13.0	226.0	18.0	20.178042
70	71.0	Auburn Gresham	4.0	27.6	28.3	18.5	41.9	15528	74.0	12448101	JE331623	01/01/2012 12:00:00 AM	079XX S ELIZABETH ST	1195	DECEPTIVE PRACTICE	FINANCIAL EXPLOITATION OF AN ELDERLY OR DISABL...	RESIDENCE	False	False	612	6	21	71.0	11	NaN	NaN	2012	08/10/2021 03:41:28 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15.192430
71	72.0	Beverly	0.9	5.1	8.0	3.7	40.5	39523	12.0	8692747	HV368620	01/01/2012 12:00:00 AM	090XX S OAKLEY AVE	2825	OTHER OFFENSE	HARASSMENT BY TELEPHONE	RESIDENCE	False	False	2221	22	19	72.0	26	1162617.0	1844687.0	2012	02/04/2016 06:33:39 AM	41.729470	-87.679883	(41.729469531, -87.679882632)	33.0	22212.0	71.0	627.0	42.0	59.0	9.0	245.0	19.0	29.906542
72	73.0	Washington Height	1.1	16.9	20.8	13.7	42.6	19713	48.0	12586134	JF104706	01/01/2012 12:00:00 AM	010XX W 97TH PL	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	NaN	False	False	2223	22	34	73.0	11	NaN	NaN	2012	01/07/2022 03:44:31 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	18.636364
73	74.0	Mount Greenwood	1.0	3.4	8.7	4.3	36.8	34381	16.0	9566017	HX216941	01/01/2012 12:01:00 AM	032XX W 114TH ST	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	True	2211	22	19	74.0	20	1156983.0	1829019.0	2012	09/07/2021 03:41:02 PM	41.686589	-87.700943	(41.686589225, -87.70094317)	33.0	4447.0	73.0	264.0	42.0	33.0	9.0	254.0	19.0	29.601227
74	75.0	Morgan Park	0.8	13.2	15.0	10.8	40.3	27149	30.0	8903224	HV577354	01/01/2012 12:00:00 AM	013XX W 112TH PL	841	THEFT	FINANCIAL ID THEFT:$300 &UNDER	RESIDENCE	False	False	2234	22	34	75.0	06	1169238.0	1830118.0	2012	02/10/2018 03:50:01 PM	41.689349	-87.656048	(41.689349439, -87.656047862)	45.0	22212.0	74.0	663.0	22.0	13.0	9.0	263.0	21.0	23.643123
75	76.0	O'Hare	3.6	15.4	7.1	10.9	30.3	25828	24.0	8421756	HV100392	01/01/2012 05:30:00 AM	052XX N OAKVIEW AVE	1365	CRIMINAL TRESPASS	TO RESIDENCE	OTHER	True	False	1614	16	41	76.0	26	1117315.0	1933551.0	2012	02/10/2018 03:50:01 PM	41.974152	-87.843985	(41.9741522, -87.843985377)	34.0	4448.0	75.0	8.0	29.0	31.0	12.0	44.0	41.0	31.203224
76	77.0	Edgewater	4.1	18.2	9.2	9.7	23.8	33385	19.0	11206130	JB117907	01/01/2012 12:00:00 AM	059XX N RIDGE AVE	266	CRIM SEXUAL ASSAULT	PREDATORY	RESIDENCE	False	True	2013	20	48	77.0	02	NaN	NaN	2012	05/14/2019 04:05:19 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30.444104
77	NaN	CHICAGO	4.7	19.7	12.9	19.5	33.5	28202	NaN	8421956	HV100653	01/01/2012 11:15:00 AM	083XX S HOLLAND RD	860	THEFT	RETAIL THEFT	DEPARTMENT STORE	True	False	622	6	21	NaN	06	1175640.0	1849717.0	2012	02/04/2016 06:33:39 AM	41.742991	-87.632026	(41.742991296, -87.632025815)	18.0	21554.0	40.0	1.0	13.0	59.0	20.0	236.0	21.0	NaN

	Community Area Number	COMMUNITY AREA NAME	PERCENT OF HOUSING CROWDED	PERCENT HOUSEHOLDS BELOW POVERTY	PERCENT AGED 16+ UNEMPLOYED	PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA	PERCENT AGED UNDER 18 OR OVER 64	PER CAPITA INCOME	HARDSHIP INDEX	ID	Case Number	Date	Block	IUCR	Primary Type	Description	Location Description	Arrest	Domestic	Beat	District	Ward	Community Area	FBI Code	X Coordinate	Y Coordinate	Year	Updated On	Latitude	Longitude	Location	Historical Wards 2003-2015	Zip Codes	Community Areas	Census Tracts	Wards	Boundaries - ZIP Codes	Police Districts	Police Beats	Wards 2023-	Theft Percentage	Theft Count
0	1.0	Rogers Park	7.7	23.6	8.7	18.2	27.5	23939	39.0	8522872	HV199799	01/01/2012 12:01:00 AM	068XX N SHERIDAN RD	890	THEFT	FROM BUILDING	RESIDENCE	False	False	2431	24	49	1.0	06	1166981.0	1945453.0	2012	02/04/2016 06:33:39 AM	42.005888	-87.661005	(42.005887804, -87.661005031)	3.0	21853.0	10.0	267.0	5.0	9.0	11.0	39.0	49.0	20.071159	959.0
1	2.0	West Ridge	7.8	17.2	8.8	20.8	38.5	23040	46.0	8481432	HV158191	01/01/2012 12:00:00 AM	066XX N SEELEY AVE	1754	OFFENSE INVOLVING CHILDREN	AGG SEX ASSLT OF CHILD FAM MBR	RESIDENCE	False	False	2412	24	50	2.0	02	1161424.0	1944172.0	2012	02/10/2018 03:50:01 PM	42.002491	-87.681486	(42.002490631, -87.681485671)	42.0	22528.0	20.0	320.0	27.0	12.0	11.0	46.0	40.0	24.220322	963.0
2	3.0	Uptown	3.8	24.0	8.9	11.8	22.2	35787	20.0	9786892	HX434641	01/01/2012 12:00:00 AM	008XX W EASTWOOD AVE	266	CRIM SEXUAL ASSAULT	PREDATORY	RESIDENCE	False	True	1914	19	46	3.0	02	1169806.0	1931096.0	2012	02/10/2018 03:50:01 PM	41.966431	-87.651032	(41.966430564, -87.651032417)	37.0	22616.0	31.0	19.0	39.0	15.0	5.0	4.0	46.0	27.005240	1340.0
3	4.0	Lincoln Square	3.4	10.9	8.2	13.4	25.5	37524	17.0	8639260	HV313362	01/01/2012 12:01:00 AM	048XX N CLAREMONT AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	2031	20	47	4.0	06	1159822.0	1932094.0	2012	02/04/2016 06:33:39 AM	41.969381	-87.687714	(41.969381427, -87.687714236)	13.0	21849.0	6.0	54.0	18.0	20.0	2.0	61.0	47.0	29.720430	691.0
4	5.0	North Center	0.3	7.5	5.2	4.5	26.2	57123	6.0	8719401	HV387013	01/01/2012 12:00:00 AM	040XX N HOYNE AVE	1563	SEX OFFENSE	CRIMINAL SEXUAL ABUSE	RESIDENCE	False	False	1911	19	47	5.0	17	1161635.0	1926718.0	2012	02/04/2016 06:33:39 AM	41.954592	-87.681198	(41.954591739, -87.681198274)	13.0	21538.0	46.0	623.0	18.0	39.0	5.0	10.0	47.0	35.475444	679.0
5	6.0	Lake View	1.1	11.4	4.7	2.6	17.0	60058	5.0	8856125	HV529988	01/01/2012 12:00:00 AM	006XX W CORNELIA AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	1925	19	46	6.0	06	1171080.0	1923465.0	2012	02/10/2018 03:50:01 PM	41.945463	-87.646573	(41.945462922, -87.646573015)	38.0	4449.0	57.0	730.0	25.0	22.0	5.0	18.0	44.0	37.566967	2875.0
6	7.0	Lincoln Park	0.8	12.3	5.1	3.6	21.5	71551	2.0	8424740	HV103697	01/01/2012 12:00:00 AM	014XX W FULLERTON AVE	460	BATTERY	SIMPLE	APARTMENT	False	False	1931	19	32	7.0	08B	1166102.0	1916039.0	2012	02/10/2018 03:50:01 PM	41.925194	-87.665083	(41.925193578, -87.66508297)	16.0	21190.0	68.0	770.0	11.0	16.0	5.0	173.0	32.0	44.323671	2202.0
7	8.0	Near North Side	1.9	12.9	7.0	2.5	22.6	88669	1.0	8904856	HV578917	01/01/2012 12:00:00 AM	002XX E CHESTNUT ST	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	1833	18	42	8.0	06	1178637.0	1906397.0	2012	02/10/2018 03:50:01 PM	41.898458	-87.619319	(41.898458275, -87.619318967)	22.0	21182.0	37.0	233.0	11.0	6.0	14.0	71.0	2.0	48.858488	5500.0
8	9.0	Edison Park	1.1	3.3	6.5	7.4	35.3	40959	8.0	9274751	HW419186	01/01/2012 12:00:00 AM	073XX N ORIOLE AVE	2825	OTHER OFFENSE	HARASSMENT BY TELEPHONE	RESIDENCE	False	False	1611	16	41	9.0	26	1124738.0	1948147.0	2012	02/10/2018 03:50:01 PM	42.014085	-87.816364	(42.014085475, -87.81636423)	34.0	22243.0	77.0	653.0	29.0	17.0	12.0	34.0	41.0	22.442244	68.0
9	10.0	Norwood Park	2.0	5.4	9.0	11.5	39.5	32875	21.0	9055356	HW199594	01/01/2012 12:00:00 AM	057XX N WEST CIRCLE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	STREET	False	False	1612	16	41	10.0	06	1127968.0	1937874.0	2012	02/10/2018 03:50:01 PM	41.985841	-87.804712	(41.985841282, -87.8047123)	34.0	22243.0	36.0	733.0	29.0	17.0	12.0	45.0	41.0	28.156028	397.0
10	11.0	Jefferson Park	2.7	8.6	12.4	13.4	35.5	27751	25.0	11865218	JC471748	01/01/2012 12:00:00 AM	062XX W FOSTER AVE	1750	OFFENSE INVOLVING CHILDREN	CHILD ABUSE	CHURCH/SYNAGOGUE/PLACE OF WORSHIP	False	True	1622	16	45	11.0	08B	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25.854701	363.0
11	12.0	Forest Glen	1.1	7.5	6.8	4.9	40.5	44164	11.0	8548806	HV224880	01/01/2012 12:01:00 AM	062XX N KEYSTONE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	STREET	False	False	1711	17	39	12.0	06	1148230.0	1941153.0	2012	02/04/2016 06:33:39 AM	41.994472	-87.730104	(41.9944717, -87.730103763)	28.0	22532.0	12.0	713.0	38.0	18.0	1.0	53.0	39.0	30.292599	176.0
12	13.0	North Park	3.9	13.2	9.9	14.4	39.0	26576	33.0	8679089	HV354082	01/01/2012 12:01:00 AM	040XX W PETERSON AVE	2820	OTHER OFFENSE	TELEPHONE THREAT	MEDICAL/DENTAL OFFICE	False	False	1711	17	39	13.0	26	1148144.0	1939564.0	2012	02/04/2016 06:33:39 AM	41.990113	-87.730461	(41.990113051, -87.730461261)	28.0	22532.0	13.0	748.0	38.0	18.0	1.0	53.0	39.0	30.252101	324.0
13	14.0	Albany Park	11.3	19.2	10.0	32.9	32.0	21323	53.0	8519160	HV194208	01/01/2012 12:00:00 AM	047XX N HARDING AVE	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	False	1723	17	39	14.0	17	1149205.0	1931162.0	2012	02/04/2016 06:33:39 AM	41.967037	-87.726777	(41.96703686, -87.726777496)	28.0	21849.0	14.0	117.0	12.0	20.0	1.0	9.0	33.0	20.816327	612.0
14	15.0	Portage Park	4.1	11.6	12.6	19.3	34.0	24336	35.0	8460773	HV138026	01/01/2012 12:00:00 AM	050XX W WARWICK AVE	1563	SEX OFFENSE	CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	1634	16	45	15.0	17	1142107.0	1924463.0	2012	09/07/2021 03:41:02 PM	41.948789	-87.753043	(41.948789141, -87.753043017)	20.0	22618.0	15.0	360.0	50.0	21.0	12.0	26.0	30.0	25.741142	1068.0
15	16.0	Irving Park	6.3	13.1	10.0	22.4	31.6	27249	34.0	8612446	HV286559	01/01/2012 12:01:00 AM	032XX N KILDARE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	1731	17	31	16.0	06	1147143.0	1921400.0	2012	02/04/2016 06:33:39 AM	41.940289	-87.734610	(41.940288955, -87.734610033)	7.0	22618.0	16.0	328.0	21.0	21.0	1.0	25.0	30.0	21.792261	856.0
16	17.0	Dunning	5.2	10.6	10.0	16.2	33.6	26282	28.0	8630608	HV304221	01/01/2012 12:00:00 AM	065XX W BYRON ST	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	1632	16	38	17.0	17	1132230.0	1925250.0	2012	02/04/2016 06:33:39 AM	41.951127	-87.789331	(41.951126516, -87.789331374)	25.0	22254.0	17.0	444.0	19.0	52.0	12.0	17.0	38.0	23.402007	443.0
17	18.0	Montclaire	8.1	15.3	13.8	23.5	38.6	22014	50.0	13184630	JG330270	01/01/2012 12:00:00 AM	070XX W DIVERSEY AVE	1754	OFFENSE INVOLVING CHILDREN	AGGRAVATED SEXUAL ASSAULT OF CHILD BY FAMILY M...	APARTMENT	False	True	2511	25	29	18.0	02	NaN	NaN	2012	08/23/2023 03:41:55 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20.079787	151.0
18	19.0	Belmont Cragin	10.8	18.7	14.6	37.3	37.3	15461	70.0	10433096	HZ170962	01/01/2012 12:00:00 AM	026XX N MC VICKER AVE	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	True	True	2512	25	29	19.0	17	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	19.055862	1211.0
19	20.0	Hermosa	6.9	20.5	13.1	41.6	36.4	15089	71.0	11002368	JA329407	01/01/2012 12:00:00 AM	021XX N KENNETH AVE	1752	OFFENSE INVOLVING CHILDREN	AGG CRIM SEX ABUSE FAM MEMBER	RESIDENCE	False	True	2522	25	31	20.0	20	NaN	NaN	2012	11/27/2017 03:53:35 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16.113281	330.0
20	21.0	Avondale	6.0	15.3	9.2	24.7	31.0	20039	42.0	9485925	HX138962	01/01/2012 12:00:00 AM	033XX N KEDZIE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	OTHER	False	False	1733	17	33	21.0	06	1154463.0	1921987.0	2012	02/04/2016 06:33:39 AM	41.941756	-87.707691	(41.941756281, -87.70769069)	15.0	21538.0	22.0	138.0	12.0	39.0	1.0	23.0	35.0	21.376147	699.0
21	22.0	Logan Square	3.2	16.8	8.2	14.8	26.2	31908	23.0	8580117	HV254276	01/01/2012 12:00:00 AM	037XX W LYNDALE ST	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	True	2525	25	35	22.0	20	1151032.0	1914695.0	2012	02/04/2016 06:33:39 AM	41.921814	-87.720493	(41.921814446, -87.720492698)	15.0	22535.0	23.0	74.0	12.0	1.0	6.0	187.0	35.0	28.799527	1948.0
22	23.0	Humboldt park	14.8	33.9	17.3	35.4	38.0	13781	85.0	10440733	HZ179414	01/01/2012 12:00:00 AM	038XX W OHIO ST	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	APARTMENT	False	False	1122	11	27	23.0	11	NaN	NaN	2012	03/09/2016 04:05:56 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14.008582	1567.0
23	24.0	West Town	2.3	14.7	6.6	12.9	21.7	43198	10.0	8647985	HV322951	01/01/2012 12:00:00 AM	015XX N CAMPBELL AVE	1305	CRIMINAL DAMAGE	CRIMINAL DEFACEMENT	RESIDENCE-GARAGE	False	False	1423	14	1	24.0	14	1159459.0	1910195.0	2012	02/04/2016 06:33:39 AM	41.909297	-87.689654	(41.909296674, -87.689653613)	10.0	21560.0	25.0	302.0	41.0	4.0	7.0	62.0	1.0	32.515020	3139.0
24	25.0	Austin	6.3	28.6	22.6	24.4	37.9	15957	73.0	10401057	HZ137709	01/01/2012 12:00:00 AM	050XX W HURON ST	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	1532	15	28	25.0	17	NaN	NaN	2012	02/11/2016 03:47:22 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15.036232	3154.0
25	26.0	West Garfield Park	9.4	41.7	25.8	24.5	43.6	10934	92.0	8421939	HV100656	01/01/2012 12:00:00 AM	044XX W WEST END AVE	890	THEFT	FROM BUILDING	RESIDENCE	False	False	1113	11	28	26.0	06	1146850.0	1900608.0	2012	02/04/2016 06:33:39 AM	41.883239	-87.736219	(41.883239213, -87.73621892)	11.0	21572.0	27.0	732.0	23.0	30.0	16.0	90.0	28.0	12.610586	841.0
26	27.0	East Garfield Park	8.2	42.4	19.6	21.3	43.2	12961	83.0	9087981	HW232769	01/01/2012 12:00:00 AM	008XX S INDEPENDENCE BLVD	841	THEFT	FINANCIAL ID THEFT:$300 &UNDER	RESIDENCE	False	False	1133	11	24	27.0	06	1151390.0	1896019.0	2012	02/10/2018 03:50:01 PM	41.870559	-87.719668	(41.870558601, -87.719668116)	36.0	21572.0	28.0	704.0	14.0	30.0	16.0	141.0	24.0	13.619433	841.0
27	28.0	Near West Side	3.8	20.6	10.7	9.6	22.2	44689	15.0	8678186	HV352296	01/01/2012 12:00:00 AM	013XX W WASHBURNE AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	False	1231	12	2	28.0	20	1167691.0	1894516.0	2012	02/04/2016 06:33:39 AM	41.866099	-87.659865	(41.866098868, -87.659865054)	48.0	14920.0	29.0	96.0	26.0	43.0	15.0	150.0	28.0	35.867363	3364.0
28	29.0	North Lawndale	7.4	43.1	21.2	27.6	42.7	12034	87.0	9467940	HX120966	01/01/2012 12:00:00 AM	015XX S KEELER AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	1012	10	24	29.0	06	1148635.0	1892193.0	2012	02/10/2018 03:50:01 PM	41.860113	-87.729881	(41.860113198, -87.729881467)	36.0	21569.0	30.0	761.0	14.0	57.0	21.0	109.0	24.0	13.414282	1392.0
29	30.0	South Lawndale	15.2	30.7	15.8	54.8	33.8	10402	96.0	11861733	JC473689	01/01/2012 12:00:00 AM	022XX S CALIFORNIA AVE	1754	OFFENSE INVOLVING CHILDREN	AGG SEX ASSLT OF CHILD FAM MBR	RESIDENCE	False	True	1033	10	12	30.0	02	NaN	NaN	2012	10/16/2019 09:37:36 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16.730236	965.0
30	31.0	Lower West Side	9.6	25.8	15.8	40.7	32.6	16444	76.0	8538123	HV214939	01/01/2012 12:01:00 AM	021XX W 18TH ST	1754	OFFENSE INVOLVING CHILDREN	AGG SEX ASSLT OF CHILD FAM MBR	RESIDENCE	False	False	1223	12	25	31.0	02	1162499.0	1891389.0	2012	02/04/2016 06:33:39 AM	41.857628	-87.679013	(41.857628272, -87.679012753)	8.0	14920.0	33.0	4.0	26.0	43.0	15.0	121.0	25.0	20.408163	670.0
31	32.0	Loop	1.5	14.7	5.7	3.1	13.5	65526	3.0	11655969	JC225381	01/01/2012 12:00:00 AM	001XX W RANDOLPH ST	486	BATTERY	DOMESTIC BATTERY SIMPLE	RESIDENCE	False	True	122	1	42	32.0	08B	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	53.431563	4134.0
32	33.0	Near South Side	1.3	13.8	4.9	7.4	21.8	59077	7.0	8812790	HV485714	01/01/2012 12:01:00 AM	022XX S WABASH AVE	1150	DECEPTIVE PRACTICE	CREDIT CARD FRAUD	OTHER	False	False	131	1	2	33.0	11	1177098.0	1889498.0	2012	02/10/2018 03:50:01 PM	41.852121	-87.625483	(41.852121445, -87.625483421)	48.0	21194.0	34.0	193.0	9.0	40.0	22.0	94.0	8.0	39.086022	727.0
33	34.0	Armour Square	5.7	40.1	16.7	34.5	38.3	16148	82.0	8421660	HV100180	01/01/2012 01:20:00 AM	002XX W 26TH ST	430	BATTERY	AGGRAVATED: OTHER DANG WEAPON	PARKING LOT/GARAGE(NON.RESID.)	True	False	914	9	11	34.0	04B	1174834.0	1887065.0	2012	02/10/2018 03:50:01 PM	41.845496	-87.633866	(41.84549602, -87.633865582)	26.0	21194.0	35.0	346.0	48.0	40.0	23.0	157.0	7.0	27.890268	427.0
34	35.0	Douglas	1.8	29.6	18.2	14.3	30.7	23791	47.0	10532867	HZ276514	01/01/2012 12:00:00 AM	036XX S RHODES AVE	1563	SEX OFFENSE	CRIMINAL SEXUAL ABUSE	APARTMENT	False	True	212	2	4	35.0	17	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	24.791893	685.0
35	36.0	Oakland	1.3	39.7	28.7	18.4	40.4	19252	78.0	8421472	HV100138	01/01/2012 01:38:00 AM	042XX S DREXEL BLVD	486	BATTERY	DOMESTIC BATTERY SIMPLE	APARTMENT	False	True	2123	2	4	36.0	08B	1182889.0	1876982.0	2012	02/10/2018 03:50:01 PM	41.817644	-87.604619	(41.817643766, -87.604618853)	1.0	4301.0	2.0	220.0	10.0	36.0	24.0	104.0	9.0	20.984456	162.0
36	37.0	Fuller Park	3.2	51.2	33.9	26.6	44.9	10432	97.0	9836248	HX484599	01/01/2012 12:00:00 AM	001XX W GARFIELD BLVD	1130	DECEPTIVE PRACTICE	FRAUD OR CONFIDENCE GAME	CURRENCY EXCHANGE	True	False	225	2	3	37.0	11	1176228.0	1868523.0	2012	02/10/2018 03:50:01 PM	41.794584	-87.629307	(41.794583892, -87.629307346)	12.0	21559.0	66.0	166.0	9.0	37.0	24.0	111.0	20.0	20.540098	251.0
37	38.0	Grand Boulevard	3.3	29.3	24.3	15.9	39.5	23472	57.0	8424419	HV102059	01/01/2012 03:00:00 AM	046XX S PRAIRIE AVE	281	CRIM SEXUAL ASSAULT	NON-AGGRAVATED	RESIDENCE	False	False	221	2	3	38.0	02	1178818.0	1874416.0	2012	02/10/2018 03:50:01 PM	41.810696	-87.619631	(41.810696214, -87.619630513)	12.0	4301.0	4.0	354.0	9.0	36.0	24.0	98.0	8.0	17.389187	714.0
38	39.0	Kenwood	2.4	21.7	15.7	11.3	35.4	35911	26.0	8916155	HV588860	01/01/2012 12:00:00 AM	050XX S LAKE SHORE DR W	840	THEFT	FINANCIAL ID THEFT: OVER $300	APARTMENT	False	False	222	2	4	39.0	06	1188639.0	1871868.0	2012	02/10/2018 03:50:01 PM	41.803475	-87.583690	(41.803474876, -87.583690122)	1.0	21192.0	5.0	400.0	33.0	10.0	24.0	113.0	3.0	28.459821	510.0
39	40.0	Washington Park	5.6	42.1	28.6	25.4	42.8	13785	88.0	11571926	JC122968	01/01/2012 12:00:00 AM	059XX S INDIANA AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	APARTMENT	True	True	232	2	20	40.0	17	NaN	NaN	2012	08/01/2019 03:45:33 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14.751732	511.0
40	41.0	Hyde Park	1.5	18.4	8.4	4.3	26.2	39056	14.0	9091480	HW236506	01/01/2012 12:00:00 AM	055XX S COTTAGE GROVE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	235	2	5	41.0	06	1182527.0	1868455.0	2012	02/10/2018 03:50:01 PM	41.794253	-87.606211	(41.794253414, -87.606211387)	32.0	22260.0	8.0	401.0	33.0	60.0	24.0	132.0	3.0	34.500784	660.0
41	42.0	Woodlawn	2.9	30.7	23.4	16.5	36.1	18672	58.0	8821354	HV494310	01/01/2012 12:01:00 AM	063XX S ST LAWRENCE AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	STREET	False	False	312	3	20	42.0	06	1181324.0	1863129.0	2012	02/10/2018 03:50:01 PM	41.779666	-87.610787	(41.779666218, -87.61078682)	53.0	22260.0	9.0	332.0	4.0	60.0	18.0	277.0	20.0	15.501576	836.0
42	43.0	South Shore	2.8	31.1	20.0	14.0	35.7	19398	55.0	9784782	HX433977	01/01/2012 12:00:00 AM	078XX S JEFFERY BLVD	265	CRIM SEXUAL ASSAULT	AGGRAVATED: OTHER	RESIDENCE	False	True	414	4	8	43.0	02	1190897.0	1853347.0	2012	09/07/2021 03:41:02 PM	41.752598	-87.576007	(41.752597535, -87.576007285)	9.0	22538.0	39.0	420.0	35.0	24.0	19.0	222.0	10.0	16.425246	1905.0
43	44.0	Chatham	3.3	27.8	24.0	14.5	40.3	18881	60.0	11012707	JA342665	01/01/2012 12:00:00 AM	081XX S EVANS AVE	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	OTHER	False	False	631	6	6	44.0	11	NaN	NaN	2012	07/11/2017 03:48:22 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22.336009	1614.0
44	45.0	Avalon Park	1.4	17.2	21.1	10.6	39.3	24454	41.0	8453833	HV101813	01/01/2012 12:01:00 AM	080XX S WOODLAWN AVE	1320	CRIMINAL DAMAGE	TO VEHICLE	STREET	False	False	411	4	8	45.0	14	1185609.0	1851926.0	2012	02/10/2018 03:50:01 PM	41.748824	-87.595430	(41.748824266, -87.595429995)	9.0	21546.0	41.0	133.0	35.0	61.0	19.0	224.0	10.0	25.055432	452.0
45	46.0	South Chicago	4.7	29.8	19.7	26.6	41.1	16579	75.0	8644620	HV319861	01/01/2012 12:00:00 AM	087XX S ESCANABA AVE	4651	OTHER OFFENSE	SEX OFFENDER: FAIL REG NEW ADD	RESIDENCE	True	False	423	4	10	46.0	26	1196905.0	1847568.0	2012	02/04/2016 06:33:39 AM	41.736592	-87.554183	(41.736592286, -87.554182677)	47.0	21202.0	42.0	509.0	47.0	25.0	19.0	238.0	6.0	14.649984	925.0
46	47.0	Burnside	6.8	33.0	18.6	19.3	42.7	12515	79.0	9535590	HX189319	01/01/2012 12:00:00 AM	092XX S DREXEL AVE	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	APARTMENT	False	False	413	4	8	47.0	11	1184166.0	1844031.0	2012	02/10/2018 03:50:01 PM	41.727193	-87.600964	(41.727193361, -87.600963809)	9.0	21546.0	43.0	472.0	35.0	61.0	19.0	246.0	10.0	17.415730	93.0
47	48.0	Calumet Heights	2.1	11.5	20.0	11.0	44.0	28887	38.0	8421496	HV100177	01/01/2012 02:10:00 AM	023XX E 91ST ST	2025	NARCOTICS	POSS: HALLUCINOGENS	STREET	True	False	413	4	7	48.0	18	1193236.0	1845085.0	2012	02/10/2018 03:50:01 PM	41.729869	-87.567705	(41.729869072, -87.56770535)	43.0	21202.0	44.0	492.0	37.0	25.0	19.0	246.0	5.0	29.205852	559.0
48	49.0	Roseland	2.5	19.8	20.3	16.9	41.2	17949	52.0	8630662	HV304328	01/01/2012 12:00:00 AM	111XX S PARNELL AVE	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	2233	22	34	49.0	17	1174621.0	1831009.0	2012	02/04/2016 06:33:39 AM	41.691677	-87.636314	(41.691676649, -87.636314398)	45.0	21861.0	45.0	486.0	22.0	19.0	9.0	258.0	21.0	15.912117	1434.0
49	50.0	Pullman	1.5	21.6	22.8	13.1	38.6	20588	51.0	10579715	HZ328636	01/01/2012 12:00:00 AM	007XX E 105TH PL	1562	SEX OFFENSE	AGG CRIMINAL SEXUAL ABUSE	RESIDENCE	False	True	512	5	9	50.0	17	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16.454690	207.0
50	51.0	South Deering	4.0	29.2	16.3	21.0	39.5	14685	65.0	9006102	HW153435	01/01/2012 12:01:00 AM	097XX S BRENNAN AVE	841	THEFT	FINANCIAL ID THEFT:$300 &UNDER	RESIDENCE	False	False	431	4	7	51.0	06	1193243.0	1840695.0	2012	02/10/2018 03:50:01 PM	41.717822	-87.567823	(41.717822323, -87.567822714)	43.0	21202.0	48.0	252.0	37.0	25.0	19.0	249.0	5.0	17.918314	408.0
51	52.0	East Side	6.8	19.2	12.1	31.9	42.8	17104	64.0	9130410	HW275140	01/01/2012 12:00:00 AM	109XX S BUFFALO AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	True	432	4	10	52.0	20	1199876.0	1833114.0	2012	09/07/2021 03:41:02 PM	41.696855	-87.543784	(41.696854988, -87.54378378)	47.0	21202.0	49.0	602.0	47.0	25.0	19.0	247.0	6.0	15.531178	269.0
52	53.0	West Pullman	3.3	25.9	19.4	20.5	42.1	16563	62.0	10928592	JA154782	01/01/2012 12:00:00 AM	0000X E 118TH PL	1752	OFFENSE INVOLVING CHILDREN	AGG CRIM SEX ABUSE FAM MEMBER	RESIDENCE	True	True	532	5	9	53.0	20	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14.940518	854.0
53	54.0	Riverdale	5.8	56.5	34.6	27.5	51.5	8201	98.0	12364874	JE229312	01/01/2012 12:00:00 AM	131XX S FORRESTVILLE AVE	1581	SEX OFFENSE	NON-CONSENSUAL DISSEMINATION OF PRIVATE SEXUAL...	RESIDENCE	False	False	533	5	9	54.0	17	NaN	NaN	2012	05/14/2021 03:40:44 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11.047619	174.0
54	55.0	Hegewisch	3.3	17.1	9.6	19.2	42.9	22677	44.0	8438703	HV116214	01/01/2012 12:01:00 AM	134XX S AVENUE M	2820	OTHER OFFENSE	TELEPHONE THREAT	RESIDENCE	False	True	433	4	10	55.0	26	1201758.0	1816513.0	2012	02/10/2018 03:50:01 PM	41.651253	-87.537455	(41.65125265, -87.537454574)	47.0	22250.0	52.0	787.0	47.0	26.0	19.0	259.0	6.0	19.376694	143.0
55	56.0	Garfield Ridge	2.6	8.8	11.3	19.3	38.1	26353	32.0	8964421	HW112128	01/01/2012 12:01:00 AM	044XX S KILPATRICK AVE	841	THEFT	FINANCIAL ID THEFT:$300 &UNDER	RESIDENCE	False	False	815	8	23	56.0	06	1145771.0	1874717.0	2012	02/10/2018 03:50:01 PM	41.812211	-87.740837	(41.812211369, -87.740837061)	35.0	22248.0	53.0	566.0	28.0	56.0	13.0	105.0	22.0	22.066694	536.0
56	57.0	Archer Heights	8.5	14.1	16.5	35.9	39.2	16134	67.0	8550554	HV226299	01/01/2012 12:01:00 AM	050XX S KOLIN AVE	1752	OFFENSE INVOLVING CHILDREN	AGG CRIM SEX ABUSE FAM MEMBER	RESIDENCE	False	False	815	8	23	57.0	20	1148213.0	1870883.0	2012	02/10/2018 03:50:01 PM	41.801644	-87.731978	(41.801643749, -87.731978113)	35.0	22248.0	54.0	697.0	8.0	56.0	13.0	105.0	14.0	21.171548	253.0
57	58.0	Brighton Park	14.4	23.6	13.9	45.1	39.3	13089	84.0	10774674	HZ540883	01/01/2012 12:01:00 AM	045XX S TROY ST	266	CRIM SEXUAL ASSAULT	PREDATORY	RESIDENCE	False	True	922	9	14	58.0	02	NaN	NaN	2012	09/07/2021 03:41:02 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15.966123	509.0
58	59.0	McKinley Park	7.2	18.7	13.4	32.9	35.6	16954	61.0	8558693	HV234189	01/01/2012 12:00:00 AM	037XX S WOLCOTT AVE	610	BURGLARY	FORCIBLE ENTRY	RESIDENCE	False	False	912	9	11	59.0	05	1164301.0	1879957.0	2012	02/04/2016 06:33:39 AM	41.826220	-87.672721	(41.826219832, -87.67272111)	26.0	14924.0	56.0	720.0	1.0	37.0	23.0	165.0	12.0	27.761194	372.0
59	60.0	Bridgeport	4.5	18.9	13.7	22.2	31.3	22694	43.0	8697316	HV373879	01/01/2012 12:00:00 AM	027XX S EMERALD AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	False	914	9	11	60.0	20	1171748.0	1886502.0	2012	02/04/2016 06:33:39 AM	41.844020	-87.645207	(41.844019513, -87.645207358)	26.0	21194.0	58.0	688.0	48.0	40.0	23.0	157.0	7.0	23.706100	513.0
60	61.0	New City	11.9	29.0	23.0	41.5	38.9	12765	91.0	11419858	JB400896	01/01/2012 12:00:00 AM	047XX S WOOD ST	1754	OFFENSE INVOLVING CHILDREN	AGG SEX ASSLT OF CHILD FAM MBR	APARTMENT	True	True	931	9	15	61.0	02	NaN	NaN	2012	01/24/2019 04:13:10 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16.715586	1139.0
61	62.0	West Elsdon	11.1	15.6	16.7	37.0	37.7	15754	69.0	8509166	HV186479	01/01/2012 12:01:00 AM	051XX S PULASKI RD	1305	CRIMINAL DAMAGE	CRIMINAL DEFACEMENT	DEPARTMENT STORE	True	False	815	8	23	62.0	14	1150563.0	1870470.0	2012	02/10/2018 03:50:01 PM	41.800465	-87.723370	(41.800464977, -87.723370404)	35.0	22248.0	60.0	792.0	6.0	56.0	13.0	129.0	23.0	21.418129	293.0
62	63.0	Gage Park	15.8	23.4	18.2	51.5	38.8	12171	93.0	8688452	HV363336	01/01/2012 12:00:00 AM	055XX S HOMAN AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	OTHER	False	False	822	8	14	63.0	06	1154655.0	1867673.0	2012	02/04/2016 06:33:39 AM	41.792709	-87.708438	(41.792708947, -87.708438164)	49.0	21867.0	61.0	801.0	8.0	58.0	13.0	129.0	14.0	17.424946	563.0
63	64.0	Clearing	2.7	8.9	9.5	18.8	37.6	25113	29.0	9030494	HW173536	01/01/2012 12:00:00 AM	063XX W 63RD ST	890	THEFT	FROM BUILDING	BANK	False	False	812	8	23	64.0	06	1135055.0	1862066.0	2012	02/10/2018 03:50:01 PM	41.777691	-87.780442	(41.777690785, -87.780442441)	35.0	22268.0	62.0	265.0	15.0	7.0	13.0	272.0	13.0	20.194647	249.0
64	65.0	West Lawn	5.8	14.9	9.6	33.6	39.6	16907	56.0	10244439	HY432505	01/01/2012 12:00:00 AM	039XX W 63RD PL	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	RESIDENCE	False	False	823	8	13	65.0	11	1151174.0	1862198.0	2012	02/10/2018 03:50:01 PM	41.777753	-87.721346	(41.777753427, -87.721345586)	23.0	21867.0	63.0	238.0	15.0	58.0	13.0	276.0	23.0	32.592593	792.0
65	66.0	Chicago Lawn	7.6	27.9	17.1	31.2	40.6	13231	80.0	8511440	HV188411	01/01/2012 12:00:00 AM	030XX W 64TH ST	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	823	8	15	66.0	06	1157262.0	1862044.0	2012	02/04/2016 06:33:39 AM	41.777210	-87.699031	(41.777209768, -87.69903082)	44.0	21867.0	64.0	319.0	31.0	58.0	13.0	276.0	15.0	15.625000	1340.0
66	67.0	West Englewood	4.8	34.4	35.9	26.3	40.7	11317	89.0	8422478	HV100112	01/01/2012 12:00:00 AM	057XX S THROOP ST	486	BATTERY	DOMESTIC BATTERY SIMPLE	VEHICLE NON-COMMERCIAL	False	True	713	7	16	67.0	08B	1168636.0	1866805.0	2012	09/07/2021 03:41:02 PM	41.790037	-87.657197	(41.790036743, -87.657196537)	19.0	22257.0	65.0	297.0	2.0	23.0	17.0	266.0	16.0	15.349910	1531.0
67	68.0	Englewood	3.8	46.6	28.0	28.5	42.5	11888	94.0	8489737	HV166954	01/01/2012 12:00:00 AM	067XX S NORMAL BLVD	1150	DECEPTIVE PRACTICE	CREDIT CARD FRAUD	RESIDENCE	False	False	722	7	6	68.0	11	1174118.0	1859976.0	2012	02/10/2018 03:50:01 PM	41.771177	-87.637298	(41.771177146, -87.637298335)	31.0	21559.0	66.0	479.0	32.0	11.0	17.0	201.0	4.0	15.333774	1392.0
68	69.0	Greater Grand Crossing	3.6	29.6	23.0	16.5	41.0	17285	66.0	8577653	HV252006	01/01/2012 12:01:00 AM	001XX E 78TH ST	2825	OTHER OFFENSE	HARASSMENT BY TELEPHONE	APARTMENT	False	False	623	6	6	69.0	26	1178686.0	1853331.0	2012	02/04/2016 06:33:39 AM	41.752840	-87.620756	(41.752839871, -87.620755566)	31.0	21546.0	67.0	475.0	32.0	61.0	20.0	228.0	4.0	15.270766	1331.0
69	70.0	Ashburn	4.0	10.4	11.7	17.7	36.9	23482	37.0	8621247	HV291039	01/01/2012 12:00:00 AM	028XX W 84TH PL	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	835	8	18	70.0	06	1158673.0	1848550.0	2012	02/04/2016 06:33:39 AM	41.740151	-87.694226	(41.740151493, -87.694225587)	6.0	4300.0	69.0	217.0	30.0	8.0	13.0	226.0	18.0	20.178042	544.0
70	71.0	Auburn Gresham	4.0	27.6	28.3	18.5	41.9	15528	74.0	12448101	JE331623	01/01/2012 12:00:00 AM	079XX S ELIZABETH ST	1195	DECEPTIVE PRACTICE	FINANCIAL EXPLOITATION OF AN ELDERLY OR DISABL...	RESIDENCE	False	False	612	6	21	71.0	11	NaN	NaN	2012	08/10/2021 03:41:28 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15.192430	1429.0
71	72.0	Beverly	0.9	5.1	8.0	3.7	40.5	39523	12.0	8692747	HV368620	01/01/2012 12:00:00 AM	090XX S OAKLEY AVE	2825	OTHER OFFENSE	HARASSMENT BY TELEPHONE	RESIDENCE	False	False	2221	22	19	72.0	26	1162617.0	1844687.0	2012	02/04/2016 06:33:39 AM	41.729470	-87.679883	(41.729469531, -87.679882632)	33.0	22212.0	71.0	627.0	42.0	59.0	9.0	245.0	19.0	29.906542	352.0
72	73.0	Washington Height	1.1	16.9	20.8	13.7	42.6	19713	48.0	12586134	JF104706	01/01/2012 12:00:00 AM	010XX W 97TH PL	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	NaN	False	False	2223	22	34	73.0	11	NaN	NaN	2012	01/07/2022 03:44:31 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	18.636364	738.0
73	74.0	Mount Greenwood	1.0	3.4	8.7	4.3	36.8	34381	16.0	9566017	HX216941	01/01/2012 12:01:00 AM	032XX W 114TH ST	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	True	2211	22	19	74.0	20	1156983.0	1829019.0	2012	09/07/2021 03:41:02 PM	41.686589	-87.700943	(41.686589225, -87.70094317)	33.0	4447.0	73.0	264.0	42.0	33.0	9.0	254.0	19.0	29.601227	193.0
74	75.0	Morgan Park	0.8	13.2	15.0	10.8	40.3	27149	30.0	8903224	HV577354	01/01/2012 12:00:00 AM	013XX W 112TH PL	841	THEFT	FINANCIAL ID THEFT:$300 &UNDER	RESIDENCE	False	False	2234	22	34	75.0	06	1169238.0	1830118.0	2012	02/10/2018 03:50:01 PM	41.689349	-87.656048	(41.689349439, -87.656047862)	45.0	22212.0	74.0	663.0	22.0	13.0	9.0	263.0	21.0	23.643123	636.0
75	76.0	O'Hare	3.6	15.4	7.1	10.9	30.3	25828	24.0	8421756	HV100392	01/01/2012 05:30:00 AM	052XX N OAKVIEW AVE	1365	CRIMINAL TRESPASS	TO RESIDENCE	OTHER	True	False	1614	16	41	76.0	26	1117315.0	1933551.0	2012	02/10/2018 03:50:01 PM	41.974152	-87.843985	(41.9741522, -87.843985377)	34.0	4448.0	75.0	8.0	29.0	31.0	12.0	44.0	41.0	31.203224	542.0
76	77.0	Edgewater	4.1	18.2	9.2	9.7	23.8	33385	19.0	11206130	JB117907	01/01/2012 12:00:00 AM	059XX N RIDGE AVE	266	CRIM SEXUAL ASSAULT	PREDATORY	RESIDENCE	False	True	2013	20	48	77.0	02	NaN	NaN	2012	05/14/2019 04:05:19 PM	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30.444104	994.0
77	NaN	CHICAGO	4.7	19.7	12.9	19.5	33.5	28202	NaN	8421956	HV100653	01/01/2012 11:15:00 AM	083XX S HOLLAND RD	860	THEFT	RETAIL THEFT	DEPARTMENT STORE	True	False	622	6	21	NaN	06	1175640.0	1849717.0	2012	02/04/2016 06:33:39 AM	41.742991	-87.632026	(41.742991296, -87.632025815)	18.0	21554.0	40.0	1.0	13.0	59.0	20.0	236.0	21.0	NaN	NaN

	ID	Case Number	Date	Block	IUCR	Primary Type	Description	Location Description	Arrest	Domestic	...	Location	Historical Wards 2003-2015	Zip Codes	Community Areas	Census Tracts	Wards	Boundaries - ZIP Codes	Police Districts	Police Beats	Wards 2023-
0	8953937	HW102973	12/31/2012 11:58:00 PM	037XX N NORA AVE	0610	BURGLARY	FORCIBLE ENTRY	RESIDENCE-GARAGE	False	False	...	(41.947761848, -87.802170774)	39.0	22254.0	17.0	444.0	19.0	52.0	12.0	17.0	38.0
1	8954299	HW100700	12/31/2012 11:55:00 PM	058XX S MARYLAND AVE	0890	THEFT	FROM BUILDING	HOSPITAL BUILDING/GROUNDS	False	False	...	(41.788699253, -87.604954085)	32.0	22260.0	8.0	154.0	33.0	60.0	24.0	132.0	3.0
2	8950836	HW100039	12/31/2012 11:55:00 PM	0000X E OHIO ST	2890	PUBLIC PEACE VIOLATION	OTHER VIOLATION	SIDEWALK	True	False	...	(41.892507592, -87.626223996)	22.0	21182.0	37.0	626.0	36.0	6.0	14.0	74.0	42.0
3	8950918	HW100021	12/31/2012 11:55:00 PM	035XX W MONTROSE AVE	0610	BURGLARY	FORCIBLE ENTRY	OTHER	False	False	...	(41.961089289, -87.716314748)	2.0	21538.0	16.0	56.0	12.0	39.0	1.0	9.0	33.0
4	8951459	HW100757	12/31/2012 11:50:00 PM	028XX N HALSTED ST	0890	THEFT	FROM BUILDING	RESIDENCE	False	False	...	(41.933894393, -87.649052922)	38.0	4449.0	57.0	684.0	25.0	22.0	5.0	30.0	44.0
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
336320	8678186	HV352296	01/01/2012 12:00:00 AM	013XX W WASHBURNE AVE	1751	OFFENSE INVOLVING CHILDREN	CRIM SEX ABUSE BY FAM MEMBER	RESIDENCE	False	False	...	(41.866098868, -87.659865054)	48.0	14920.0	29.0	96.0	26.0	43.0	15.0	150.0	28.0
336321	8647985	HV322951	01/01/2012 12:00:00 AM	015XX N CAMPBELL AVE	1305	CRIMINAL DAMAGE	CRIMINAL DEFACEMENT	RESIDENCE-GARAGE	False	False	...	(41.909296674, -87.689653613)	10.0	21560.0	25.0	302.0	41.0	4.0	7.0	62.0	1.0
336322	8511440	HV188411	01/01/2012 12:00:00 AM	030XX W 64TH ST	0840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	...	(41.777209768, -87.69903082)	44.0	21867.0	64.0	319.0	31.0	58.0	13.0	276.0	15.0
336323	10928592	JA154782	01/01/2012 12:00:00 AM	0000X E 118TH PL	1752	OFFENSE INVOLVING CHILDREN	AGG CRIM SEX ABUSE FAM MEMBER	RESIDENCE	True	True	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
336324	9467940	HX120966	01/01/2012 12:00:00 AM	015XX S KEELER AVE	0840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE	False	False	...	(41.860113198, -87.729881467)	36.0	21569.0	30.0	761.0	14.0	57.0	21.0	109.0	24.0

	ID	Case Number	Date	Block	IUCR	Primary Type	Description	Location Description	Arrest	Domestic	...	Location	Historical Wards 2003-2015	Zip Codes	Community Areas	Census Tracts	Wards	Boundaries - ZIP Codes	Police Districts	Police Beats	Wards 2023-
22474	8921124	HV592953	12/03/2012 10:00:00 PM	026XX W 35TH PL	0840	THEFT	FINANCIAL ID THEFT: OVER $300	OTHER	False	False	...	(41.829258146, -87.690690891)	29.0	22248.0	55.0	638.0	1.0	56.0	23.0	96.0	12.0
155202	8706239	HV382465	07/14/2012 01:30:00 AM	052XX S MICHIGAN AVE	0890	THEFT	FROM BUILDING	OTHER	False	False	...	(41.799858243, -87.622596769)	12.0	21192.0	7.0	218.0	9.0	10.0	24.0	111.0	8.0
192972	8648938	HV324042	06/08/2012 04:15:00 AM	003XX N LA SALLE DR	0870	THEFT	POCKET-PICKING	STREET	True	False	...	(41.888599915, -87.632510468)	22.0	4446.0	37.0	670.0	36.0	55.0	14.0	73.0	42.0
219443	8609272	HV282904	05/12/2012 02:00:00 AM	019XX W DIVERSEY PKWY	0820	THEFT	$500 AND UNDER	STREET	False	False	...	(41.932306289, -87.676441918)	16.0	21190.0	68.0	649.0	40.0	16.0	5.0	172.0	32.0
87969	8813861	HV487221	09/21/2012 12:00:00 PM	007XX S CLAREMONT AVE	0820	THEFT	$500 AND UNDER	STREET	False	False	...	(41.872184627, -87.684966578)	48.0	21184.0	29.0	757.0	23.0	28.0	15.0	139.0	28.0
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
264876	8535449	HV212046	03/23/2012 08:30:00 PM	001XX W HUBBARD ST	0890	THEFT	FROM BUILDING	RESTAURANT	False	False	...	(41.890013524, -87.631664996)	22.0	4446.0	37.0	670.0	36.0	55.0	14.0	73.0	42.0
65276	8862096	HV535499	10/16/2012 04:00:00 PM	027XX E 89TH ST	0820	THEFT	$500 AND UNDER	SCHOOL, PUBLIC, BUILDING	False	False	...	(41.73365047, -87.557845321)	43.0	21202.0	42.0	508.0	37.0	25.0	19.0	238.0	5.0
280207	8510397	HV187643	03/07/2012 07:30:00 PM	054XX N CUMBERLAND AVE	0890	THEFT	FROM BUILDING	OTHER	False	False	...	(41.97855782, -87.836588785)	34.0	4448.0	36.0	735.0	29.0	31.0	12.0	44.0	41.0
192808	8650043	HV324578	06/08/2012 09:30:00 AM	024XX W ROOSEVELT RD	0820	THEFT	$500 AND UNDER	GAS STATION	False	False	...	(41.866604054, -87.686645691)	11.0	14920.0	29.0	96.0	23.0	43.0	21.0	151.0	28.0
55272	8864755	HV538265	10/27/2012 12:00:00 PM	013XX N STATE PKWY	0890	THEFT	FROM BUILDING	HOTEL/MOTEL	False	False	...	(41.906054951, -87.628752556)	22.0	14926.0	37.0	17.0	11.0	54.0	14.0	197.0	2.0